Hi, I work actually with SAP BW Connectors (SQL Server Feature Pack) and extract data out of SAP BW successfully. That's really easy. I got 2 problems prevent a live deployment: (1) Sometimes we running in problems during the "Data Transfer Processes" (DTP). When this process failes, I cant reset this DTP out of SQL Server, because I dont know a RequestID. So I have to go to the admins of SAP BW and that a lot of times... So my question: Is there a way to reset the DTP out of SQL Server Environment or an other workaround? (2) The second problems is related to problem 1. Sometimes the SSIS-process stops because of a timeout but the SAP BW processes dont stop (of course). So SAP BW prepared the data for export and wait for extracting from SSIS. How I can get an info about this status of the SAP BW processes? By trial & error I try same Execution Modes for SAP BW (P / W / E) and hope someting happens. Is there a more professional way? Thanks for your help/ advices.

Hi, I think you can try to use Script Task to resolve the problem 1. thanks, Jerry